BHARAT SEVAK SAMAJ
Time: 2 hrs. Max. Marks: 100
I. Fill in the blanks: (10 x 1 = 10)
1. Errors in general are referred to as ----------.
2. --------function returns the total number of rows without null values.
3. Oracle supports ------------set operations.
4. ----------clause is used to specify a condition to retrieve group data.
5. COMMIT is a ------------command.
6. ----------function will convert the first letter of the string to uppercase.
7. To delete rows from a table ------------command is used.
8. Oracle is a ----------.
9. Pre defined exceptions are raised ----------.
10. DROP is a ----------command.
II. State whether True or False: (10 x 1 = 10)
1. ORDER clause is used to sort the data on any key field.
2. By default sorting is in the ascending order.
3. UPPER function will convert the data into uppercase.
4. Lower function will convert the data into Capital letter.
5. Like pattern can contain wild card characters.
6. String is a fundamental data type in Oracle.
7. The outer join operator is (-).
8. DESC command is used to display the contents of a table.
9. A sub query is a query within a query.
10. Exceptions are situations without an error.
III.Answer any SIX of the following: (6 x 10 = 60)
1. What is an Exception? Explain different types of exceptions.
2. Explain Character functions and string functions with examples.
3. Write a program to check whether the given number is Armstrong or not.
4. Explain different types of Database users.
5. Write a program to check whether the given number is prime or not.
6. Explain ANSI/SPARC model.
7. Explain Codd’s Rules.
IV. Answer any ONE of the following: (1 x 20 = 20)
1. Explain in detail about Functions and procedures with examples.
2. Explain in detail about Exceptions.